home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Tech Arsenal 1
/
Tech Arsenal (Arsenal Computer).ISO
/
tek-05
/
lancos.zip
/
LANCOSTS.TXT
< prev
next >
Wrap
Text File
|
1992-02-23
|
4KB
|
110 lines
LANCOSTS.WK1 Notes
Revised 2/92
The LANCOSTS.WK1 models facility server and work group server LAN
costs. The model was written using 1-2-3 v2.3. Although it might
work without error, it has not been tested using other spreadsheet
versions.
Although real situations were used as the basis for this model, the
author can not assure that the assumptions made will be applicable
to all situations. Use this model only as an approximation. Your
reality may vary.
Various items require user input to reflect an organization's
particular perspective. Calculated fields have been protected to
prevent unintentional erasure.
Comments are welcome for improving this model.
Glenn Fund Internet: Fund@Relay.proteon.com
Principal Research Specialist CompuServe: 75170,1060
Lockheed Sanders cc:Mail Fund at Proteonwebo
DW Highway South Phone: (603) 885-6242
MS NHQ4-0405
Nashua, NH 03061
Categories and descriptions of user defined fields include:
Section 1. Assumptions
# of Users Total number of LAN users within the
organization.
Users Per Server Average estimate of users defined to each
server. Note, Defined not concurrent usage.
% Overage To This value describes when additional users
Justify New are added to existing servers and when new
Server new servers are procured. This value is the
users, above the average users per server
required to procure a new server. If average
users = 350, and overage = 20%, then a new
server is assumed when there are greater than
20% or 71 persons requiring LAN services. An
organization of 1400 people would require 4
servers. 1471 persons would require 5 servers
under this scenario.
Server/Corp. An assumption is made that there will be both
Consultant Ratio key senior strategists/consultants and LAN
Managers to run the network. This ratio sets
the number of senior strategists/consultants.
Formulas have been set to assume that more
than half of the ratio of servers to
consultants will be required before a new
person is added. In all cases, a minimum of 1
person is assumed in this category.
LAN Personnel These values describe the LAN Managers
required to run the enterprise LANs. Dollar
values are asked for Principal, Senior and
Entry positions. A mix is entered to model
the experience levels of the LAN personnel. A
mix adding up to 100% would assume 1 LAN
Manager per server. A mix of 0 would assume
no LAN Managers. A Mix of greater than 100%
would assume more than 1 LAN Manager per
server. It should be noted, that the facility
server mix does not (and most likely will not)
be the same as the numbers entered for the
smaller and less complex work group server
scenario.
Section 2. Facility/Work Group Server Investment
Cost Per Server Cost of hardware including backup unit(s).
Operating System Cost of NetWare 386 or other LAN Operating
system software.
Section 3. Other Significant LAN Investment
Ave. Cost Per
Printer
Average Users Per
Printer
Ave. Cabling Cost
Per Node
Section 4. Facility/Work Group Server Recurring Costs
Maintenance Rates Enter Facility server (hardware/software,
printer and software/upgrades maintenance
rates. All do not have to be the same. A 0%
value may be entered in any of these
categories.
Section 5. Education and Training
CNE Training Rate Your cost for CNE training courses.
Supervisory You costs for NetWare 386 supervisor training
Training Rate or equivalent if alternate operating systems
are in use.